package com.ruoyi.ly.mapper;

import com.github.pagehelper.Page;
import com.ruoyi.ly.domain.MobileQrcode;
import com.ruoyi.ly.domain.dto.PageMobileQrcodeDTO;
import com.ruoyi.ly.domain.vo.MobileQrcodeVO;
import com.ruoyi.ly.domain.vo.PageMobileQrcodeVO;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
@Mapper
public interface MobileQrcodeMapper {
    void update(MobileQrcode mobileQrcode);
    void insert(MobileQrcode mobileQrcode);
    Page<PageMobileQrcodeVO> pageQuery(PageMobileQrcodeDTO pageMobileQrcodeDTO);
    @Delete("delete from mobile_qrcode where id = #{id}")
    void delete(Long id);
    @Select("select mq.*,p.project_name from mobile_qrcode mq left join project p on mq.project_id = p.id where mq.id = #{id}")
    MobileQrcodeVO selectById(Long id);
}
